$minvalue = '2020-01-01 00:00:00'; $max_value = '2050-12-31 23:59:59'; $this->db->where("date_field BETWEEN '$minvalue' AND '$maxvalue'");